package com.kla.power.mapper;

import com.kla.power.entity.ScreenMerchantEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author WuZH
 * @since 2024-08-06
 */
@Mapper
public interface ScreenMerchantMapper extends BaseMapper<ScreenMerchantEntity> {


    @Select ( value = "select si.id,smi.title,smi.merchantId from screen_info si\n" +
            "left join screen_merchant_info smi on smi.screenId = si.id where smi.merchantId=#{screenMerchantEntity.merchantId}\n")
    List<ScreenMerchantEntity> queryList ( @Param ("screenMerchantEntity") ScreenMerchantEntity screenMerchantEntity);

}
